﻿CREATE TRIGGER [dbo].[TRG_CALENDAR_PLAN_UPDATE]
   ON  dbo.CALENDAR_PLAN
   AFTER INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE CALENDAR_PLAN
    SET LAST_UPDATE = GETDATE(), 
    LAST_UPDATE_USER = SUSER_NAME()
    WHERE ID IN (SELECT ID FROM INSERTED)
END
